package com.friday.dao;

import java.sql.Date;
import java.util.List;

import com.friday.po.SignIn;
import com.friday.po.SignInHistory;

public interface SignInHistoryDao {
	
    int insertAllSignInHistory() throws Exception;
    int insertSignInHistory(SignInHistory sih) throws Exception;
	
	int deleteSignInHistory(String id) throws Exception;
	
	int deleteSignInHistoryByDate(Date date) throws Exception;
	
	int updateSignInHistory(SignInHistory si) throws Exception;
	
	List<SignInHistory> queryAllHistory() throws Exception;
	
	List<SignInHistory> querySignInHistoryByDepartment(String department) throws Exception;
	
	List<SignInHistory> querySignInHistoryByDate(Date date) throws Exception;
	
	List<SignInHistory> querySignInHistoryByEmployee(String employee) throws Exception;
	
	SignInHistory querySignInHistoryByEmployeeAndDate(String employee, Date date) throws Exception;
	
	List<SignInHistory> querySignInHistoryBetweenDate(Date start, Date end) throws Exception;
	
	List<SignInHistory> querySignInHistoryByDeparmentBetweenDate(String depid, Date start, Date end) throws Exception;

}
